AP Invoice for Inter company transaction
The Payables Open Interface Import program is creating additional tax line in a multiple lines scenario. scenario #1:Single line item AR Invoice {single line trx) Dr. Receivables 180 Cr. Revenue 150 Cr. Tax 30 [20% tax rate] AP Invoice {single line trx) Dr. Purchases 150 DR. Tax 30 [20% tax rate] Cr. Payables 180 ------------------------ scenario #2:Multiple line item AR Invoice {multi 2 line trx) Dr. Receivables 180 Cr. Revenue 100 Cr. Revenue 50 Cr. Tax 30 [20% tax rate] AP Invoice {multi 2 line trx) Dr. Purchases 100 Dr. Purchases 50 Dr. Tax 30 [20% tax rate] Dr. Tax 30 [20% tax rate] Cr. Payables 210 Extra tax line added [error] ------------------------ scenario #3:Multiple line item AR Invoice {multi 3 line trx) Dr. Receivables 180 Cr. Revenue 100 Cr. Revenue 30 Cr. Revenue 20 Cr. Tax 30 [20% tax rate] AP Invoice {multi 3 line trx) Dr. Purchases 100 Dr. Purchases 30 Dr. Purchases 20 Dr. Tax 30 [20% tax rate] Dr. Tax 30 [20% tax rate] Dr. Tax 30 [20% tax rate] Cr. Payables 240 Extra 2 tax line added [error] ------------------------ Problem: Payables Open Interface program creates extra tax line for each additional line item inherited from Receivables. ------------------------ scenario #4:Multiple line item AR Invoice {multi 4 line trx) Dr. Receivables 180 Cr. Revenue 60 Cr. Revenue 40 Cr. Revenue 30 Cr. Revenue 20 Cr. Tax 30 [20% tax rate] AP Invoice {multi 4 line trx) Dr. Purchases 60 Dr. Purchases 40 Dr. Purchases 30 Dr. Purchases 20 Dr. Tax 30 [20% tax rate] Dr. Tax 30 [20% tax rate] Dr. Tax 30 [20% tax rate] Dr. Tax 30 [20% tax rate] Cr. Payables 270 Extra 3 tax line added [error] ----------------------- The Total AR Invoice amount is constant at 180, while Total AP Invoice is incremental with additional tax line for each additional intercompany line transaction. Please, what could be the cause? Bug in Payables Open Interface Import program or configuration settings in AGIS? Please I would appreciate your quick assistance. Thanking you in anticipation of your help. jimi.akinola@yahoo.co.uk Jimi Akinola +447527 260 073
Payables Open Interface Import program
The Payables Open Interface Import program is creating additional tax line in a multiple lines scenario. scenario #1:Single line item AR Invoice {single line trx) Dr. Receivables 180 Cr. Revenue 150 Cr. Tax 30 [20% tax rate] AP Invoice {single line trx) Dr. Purchases 150 DR. Tax 30 [20% tax rate] Cr. Payables 180 ------------------------ scenario #2:Multiple line item AR Invoice {multi 2 line trx) Dr. Receivables 180 Cr. Revenue 100 Cr. Revenue 50 Cr. Tax 30 [20% tax rate] AP Invoice {multi 2 line trx) Dr. Purchases 100 Dr. Purchases 50 Dr. Tax 30 [20% tax rate]correct Dr. Tax 30 [20% tax rate] Cr. Payables 210 Extra tax line added [error] ------------------------ scenario #3:Multiple line item AR Invoice {multi 3 line trx) Dr. Receivables 180 Cr. Revenue 100 Cr. Revenue 30 Cr. Revenue 20 Cr. Tax 30 [20% tax rate] AP Invoice {multi 3 line trx) Dr. Purchases 100 Dr. Purchases 30 Dr. Purchases 20 Dr. Tax 30 [20% tax rate] correct Dr. Tax 30 [20% tax rate] Dr. Tax 30 [20% tax rate] Cr. Payables 240 Extra 2 tax line added [error] ------------------------ Problem: Payables Open Interface program creates extra tax line for each additional line item inherited from Receivables. ------------------------ scenario #4: Multiple line item AR Invoice {multi 4 line trx) Dr. Receivables 180 Cr. Revenue 60 Cr. Revenue 40 Cr. Revenue 30 Cr. Revenue 20 Cr. Tax 30 [20% tax rate] AP Invoice [multi 4 line trx) Dr. Purchases 60 Dr. Purchases 40 Dr. Purchases 30 Dr. Purchases 20 Dr. Tax 30 [20% tax rate]correct Dr. Tax 30 [20% tax rate] Dr. Tax 30 [20% tax rate] Dr. Tax 30 [20% tax rate] Cr. Payables 270 Extra 3 tax line added [error] ----------------------- The Total AR Invoice amount is constant at 180, while Total AP Invoice is incremental with additional tax line for each additional intercompany line transaction. Please, what could be the cause? Bug in Payables Open Interface Import program or configuration settings in AGIS? Please I would appreciate your quick assistance. Thanking you in anticipation of your help. jimi.akinola@yahoo.co.uk Jimi Akinola